package LawsonTransformJava.data;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;


public class TblPRTime extends TblDate {
	public int 			company=0;
	public int 			employee=0;
	public int 			check_id=0;
	public String 		pay_sum_grp="";
	public int 			time_seq=0;
	public String 		job_code="";
	public String 		process_level="";
	public String 		work_state="";
	public float 		hours=0;
	public float 		rate=0;
	public float 		wage_amount=0;
	public String 		department="";
	public String 		pct_dist_flag="";
	public int 			r_shift=0;				//Oracle Representation
	public int			shift=0;				//MSAccess Representation
	public String 		dst_acct_unit="";
	public int 			dst_account=0;
	public int 			dst_sub_acct=0;
	public int 			dist_company=0;
	public Date 		tr_date=null;
	public String 		union_code="";
	public float 		ot_prem_amt=0;
	public float 		shift_diff=0;
	public int 			payroll_year=0;
	public int 			quarter=0;
	public int 			pcd_seq_nbr=0;
	public Date 		per_end_date=null;
	public String 		check_type="";
	public String 		locat_code="";
	public String 		wc_state="";
	public String 		ot_record="";
	public String 		position="";
	public String 		activity="";
	public String 		acct_category="";
	public String 		time_acc_flag="";
	public float 		shft_diff_rate=0;
	public float 		ot_rate=0;
	public int 			atn_obj_id=0;
	public int 			glt_obj_id=0;
	public String 		reconciled="";
	public int 			tax_freq_over=0;
	public String 		remun_code="";
	public String 		bus_nbr_grp="";
	public String 		report_entity="";
	public String 		qc_ent_nbr_grp="";
	public String 		wc_class="";
	public String 		currency_code="";
	public int 			curr_nd=0;
	public String 		hm_process_lev="";
	public String 		ca_wc_class="";
	public String 		country_code="";
	public int 			pens_seq_nbr=0;
	public int 			abn_obj_id=0;
	public float 		pay_units=0;
	public String 		unit_measure="";
	public String 		user_id="";
	public Date 		date_stamp=null;
	public int 			non_earnings=0;
	public int 			orig_obj_id=0;
	public String 		record_type="";
	public String 		attend_code="";
	public String 		reason_code="";
	public int 			tes_obj_id=0;
	public String 		retro_pension="";
	public String 		service_code="";
	public int 			time_stamp=0;
	public Date 		create_date=null;
	public int 			create_time=0;
	public String 		create_user_id="";
	public String 		prtset8_ss_sw="";
	public String 		prtset9_ss_sw="";
	//These values come from joining the PAYMASTR table to PRTIME
	public float		check_Amt=0;
	public int			check_Nbr=0;
	public Date			check_date=null;
	//These values come from joining the EMPACHDIST table to PRTIME
	public float		dist_Amount=0;

    private DateFormat df = new SimpleDateFormat("MM/dd/yyyy");

	public void setCompany(int company) {
		this.company = company;
	}
	public void setEmployee(int employee) {
		this.employee = employee;
	}
	public void setCheck_id(int check_id) {
		this.check_id = check_id;
	}
	public void setPay_sum_grp(String pay_sum_grp) {
		this.pay_sum_grp = pay_sum_grp.trim();
	}
	public void setTime_seq(int time_seq) {
		this.time_seq = time_seq;
	}
	public void setJob_code(String job_code) {
		this.job_code = job_code.trim();
	}
	public void setProcess_level(String process_level) {
		this.process_level = process_level.trim();
	}
	public void setWork_state(String work_state) {
		this.work_state = work_state.trim();
	}
	public void setHours(float hours) {
		this.hours = hours;
	}
	public void setRate(float rate) {
		this.rate = rate;
	}
	public void setWage_amount(float wage_amount) {
		this.wage_amount = wage_amount;
	}
	public void setDepartment(String department) {
		this.department = department.trim();
	}
	public void setPct_dist_flag(String pct_dist_flag) {
		this.pct_dist_flag = pct_dist_flag.trim();
	}
	public void setR_shift(int r_shift) {
		this.r_shift = r_shift;
	}
	public void setShift(int shift) {
		this.r_shift = shift;
	}
	public void setDst_acct_unit(String dst_acct_unit) {
		this.dst_acct_unit = dst_acct_unit.trim();
	}
	public void setDst_account(int dst_account) {
		this.dst_account = dst_account;
	}
	public void setDst_sub_acct(int dst_sub_acct) {
		this.dst_sub_acct = dst_sub_acct;
	}
	public void setDist_company(int dist_company) {
		this.dist_company = dist_company;
	}
	public void setTr_date(Date tr_date) {
		this.tr_date = tr_date;
	}
	public void setUnion_code(String union_code) {
		this.union_code = union_code.trim();
	}
	public void setOt_prem_amt(float ot_prem_amt) {
		this.ot_prem_amt = ot_prem_amt;
	}
	public void setShift_diff(float shift_diff) {
		this.shift_diff = shift_diff;
	}
	public void setPayroll_year(int payroll_year) {
		this.payroll_year = payroll_year;
	}
	public void setQuarter(int quarter) {
		this.quarter = quarter;
	}
	public void setPcd_seq_nbr(int pcd_seq_nbr) {
		this.pcd_seq_nbr = pcd_seq_nbr;
	}
	public void setPer_end_date(Date per_end_date) {
		this.per_end_date = per_end_date;
	}
	public void setCheck_type(String check_type) {
		this.check_type = check_type.trim();
	}
	public void setLocat_code(String locat_code) {
		this.locat_code = locat_code.trim();
	}
	public void setWc_state(String wc_state) {
		this.wc_state = wc_state.trim();
	}
	public void setOt_record(String ot_record) {
		this.ot_record = ot_record.trim();
	}
	public void setPosition(String position) {
		this.position = position.trim();
	}
	public void setActivity(String activity) {
		this.activity = activity.trim();
	}
	public void setAcct_category(String acct_category) {
		this.acct_category = acct_category.trim();
	}
	public void setTime_acc_flag(String time_acc_flag) {
		this.time_acc_flag = time_acc_flag.trim();
	}
	public void setShft_diff_rate(float shft_diff_rate) {
		this.shft_diff_rate = shft_diff_rate;
	}
	public void setOt_rate(float ot_rate) {
		this.ot_rate = ot_rate;
	}
	public void setAtn_obj_id(int atn_obj_id) {
		this.atn_obj_id = atn_obj_id;
	}
	public void setGlt_obj_id(int glt_obj_id) {
		this.glt_obj_id = glt_obj_id;
	}
	public void setReconciled(String reconciled) {
		this.reconciled = reconciled.trim();
	}
	public void setTax_freq_over(int tax_freq_over) {
		this.tax_freq_over = tax_freq_over;
	}
	public void setRemun_code(String remun_code) {
		this.remun_code = remun_code.trim();
	}
	public void setBus_nbr_grp(String bus_nbr_grp) {
		this.bus_nbr_grp = bus_nbr_grp.trim();
	}
	public void setReport_entity(String report_entity) {
		this.report_entity = report_entity.trim();
	}
	public void setQc_ent_nbr_grp(String qc_ent_nbr_grp) {
		this.qc_ent_nbr_grp = qc_ent_nbr_grp.trim();
	}
	public void setWc_class(String wc_class) {
		this.wc_class = wc_class.trim();
	}
	public void setCurrency_code(String currency_code) {
		this.currency_code = currency_code.trim();
	}
	public void setCurr_nd(int curr_nd) {
		this.curr_nd = curr_nd;
	}
	public void setHm_process_lev(String hm_process_lev) {
		this.hm_process_lev = hm_process_lev.trim();
	}
	public void setCa_wc_class(String ca_wc_class) {
		this.ca_wc_class = ca_wc_class.trim();
	}
	public void setCountry_code(String country_code) {
		this.country_code = country_code.trim();
	}
	public void setPens_seq_nbr(int pens_seq_nbr) {
		this.pens_seq_nbr = pens_seq_nbr;
	}
	public void setAbn_obj_id(int abn_obj_id) {
		this.abn_obj_id = abn_obj_id;
	}
	public void setPay_units(float pay_units) {
		this.pay_units = pay_units;
	}
	public void setUnit_measure(String unit_measure) {
		if (unit_measure != null)
			this.unit_measure = unit_measure.trim();
		else
			this.unit_measure = "";
	}
	public void setUser_id(String user_id) {
		this.user_id = user_id.trim();
	}
	public void setDate_stamp(Date date_stamp) {
		this.date_stamp = date_stamp;
	}
	public void setNon_earnings(int non_earnings) {
		this.non_earnings = non_earnings;
	}
	public void setOrig_obj_id(int orig_obj_id) {
		this.orig_obj_id = orig_obj_id;
	}
	public void setRecord_type(String record_type) {
		this.record_type = record_type.trim();
	}
	public void setAttend_code(String attend_code) {
		this.attend_code = attend_code.trim();
	}
	public void setReason_code(String reason_code) {
		this.reason_code = reason_code.trim();
	}
	public void setTes_obj_id(int tes_obj_id) {
		this.tes_obj_id = tes_obj_id;
	}
	public void setRetro_pension(String retro_pension) {
		this.retro_pension = retro_pension.trim();
	}
	public void setService_code(String service_code) {
		this.service_code = service_code.trim();
	}
	public void setTime_stamp(int time_stamp) {
		this.time_stamp = time_stamp;
	}
	public void setCreate_date(Date create_date) {
		this.create_date = create_date;
	}
	public void setCreate_time(int create_time) {
		this.create_time = create_time;
	}
	public void setCreate_user_id(String create_user_id) {
		this.create_user_id = create_user_id.trim();
	}
	public void setPrtset8_ss_sw(String prtset8_ss_sw) {
		this.prtset8_ss_sw = prtset8_ss_sw.trim();
	}
	public void setPrtset9_ss_sw(String prtset9_ss_sw) {
		this.prtset9_ss_sw = prtset9_ss_sw.trim();
	}
	public void setNet_Pay_Amt(float check_Amt) {
		this.check_Amt = check_Amt;
	}
	public void setCheck_Nbr(int check_Nbr) {
		this.check_Nbr = check_Nbr;
	}
	public void setCheck_date(Date check_date) {
		this.check_date = check_date;
	}
	public void setDist_Amount(float dist_Amount) {
		this.dist_Amount = dist_Amount;
	}
	public int getCompany() {
		return company;
	}
	public int getEmployee() {
		return employee;
	}
	public int getCheck_id() {
		return check_id;
	}
	public String getPay_sum_grp() {
		return pay_sum_grp;
	}
	public int getTime_seq() {
		return time_seq;
	}
	public String getJob_code() {
		return job_code;
	}
	public String getProcess_level() {
		return process_level;
	}
	public String getWork_state() {
		return "\"" + work_state + "\"";
	}
	public float getHours() {
		return hours;
	}
	public float getRate() {
		return rate;
	}
	public float getWage_amount() {
		return wage_amount;
	}
	public String getDepartment() {
		return department;
	}
	public String getPct_dist_flag() {
		return pct_dist_flag;
	}
	public int getR_shift() {
		return r_shift;
	}
	public int getShift() {
		return shift;
	}
	public String getDst_acct_unit() {
		return dst_acct_unit;
	}
	public int getDst_account() {
		return dst_account;
	}
	public int getDst_sub_acct() {
		return dst_sub_acct;
	}
	public int getDist_company() {
		return dist_company;
	}
	public String getTr_date() {
		return convertDate(tr_date);
	}
	public String getUnion_code() {
		return union_code;
	}
	public float getOt_prem_amt() {
		return ot_prem_amt;
	}
	public float getShift_diff() {
		return shift_diff;
	}
	public int getPayroll_year() {
		return payroll_year;
	}
	public int getQuarter() {
		return quarter;
	}
	public int getPcd_seq_nbr() {
		return pcd_seq_nbr;
	}
	public String getPer_end_date() {
		return convertDate(per_end_date);
	}
	public String getCheck_type() {
		return check_type;
	}
	public String getLocat_code() {
		return locat_code;
	}
	public String getWc_state() {
		return wc_state;
	}
	public String getOt_record() {
		return ot_record;
	}
	public String getPosition() {
		return position;
	}
	public String getActivity() {
		return activity;
	}
	public String getAcct_category() {
		return acct_category;
	}
	public String getTime_acc_flag() {
		return time_acc_flag;
	}
	public float getShft_diff_rate() {
		return shft_diff_rate;
	}
	public float getOt_rate() {
		return ot_rate;
	}
	public int getAtn_obj_id() {
		return atn_obj_id;
	}
	public int getGlt_obj_id() {
		return glt_obj_id;
	}
	public String getReconciled() {
		return reconciled;
	}
	public int getTax_freq_over() {
		return tax_freq_over;
	}
	public String getRemun_code() {
		return remun_code;
	}
	public String getBus_nbr_grp() {
		return bus_nbr_grp;
	}
	public String getReport_entity() {
		return report_entity;
	}
	public String getQc_ent_nbr_grp() {
		return qc_ent_nbr_grp;
	}
	public String getWc_class() {
		return wc_class;
	}
	public String getCurrency_code() {
		return currency_code;
	}
	public int getCurr_nd() {
		return curr_nd;
	}
	public String getHm_process_lev() {
		return hm_process_lev;
	}
	public String getCa_wc_class() {
		return ca_wc_class;
	}
	public String getCountry_code() {
		return country_code;
	}
	public int getPens_seq_nbr() {
		return pens_seq_nbr;
	}
	public int getAbn_obj_id() {
		return abn_obj_id;
	}
	public float getPay_units() {
		return pay_units;
	}
	public String getUnit_measure() {
		return unit_measure;
	}
	public String getUser_id() {
		return user_id;
	}
	public String getDate_stamp() {
		return convertDate(date_stamp);
	}
	public int getNon_earnings() {
		return non_earnings;
	}
	public int getOrig_obj_id() {
		return orig_obj_id;
	}
	public String getRecord_type() {
		return record_type;
	}
	public String getAttend_code() {
		return attend_code;
	}
	public String getReason_code() {
		return reason_code;
	}
	public int getTes_obj_id() {
		return tes_obj_id;
	}
	public String getRetro_pension() {
		return retro_pension;
	}
	public String getService_code() {
		return service_code;
	}
	public int getTime_stamp() {
		return time_stamp;
	}
	public String getCreate_date() {
		return df.format(create_date).toString();
	}
	public int getCreate_time() {
		return create_time;
	}
	public String getCreate_user_id() {
		return create_user_id;
	}
	public String getPrtset8_ss_sw() {
		return prtset8_ss_sw;
	}
	public String getPrtset9_ss_sw() {
		return prtset9_ss_sw;
	}
	public float getCheck_Amt() {
		return check_Amt;
	}
	public String getCheck_date() {
		return df.format(check_date).toString();
	}
	public float getDist_Amount() {
		return dist_Amount;
	}
	public int getCheck_Nbr() {
		return check_Nbr;
	}
	public String toString() {
		// TODO Build toString Method
		return (company + "|" + employee + "|" + check_id + "|" + pay_sum_grp + "|" + time_seq + "|" + 
				job_code + "|" + process_level + "|" + work_state + "|" + hours + "|" + rate + "|" + 
				wage_amount + "|" + department + "|" + pct_dist_flag + "|" + r_shift + "|" + dst_acct_unit + 
				"|" + dst_account + "|" + dst_sub_acct + "|" + dist_company + "|" + tr_date + "|" + union_code + 
				"|" + ot_prem_amt + "|" + shift_diff + "|" + payroll_year + "|" + quarter + "|" + pcd_seq_nbr + 
				"|" + per_end_date + "|" + check_type + "|" + locat_code + "|" + wc_state + "|" + ot_record + "|" + 
				position + "|" + activity + "|" + acct_category + "|" + time_acc_flag + "|" + shft_diff_rate + 
				"|" + ot_rate + "|" + atn_obj_id + "|" + glt_obj_id + "|" + reconciled + "|" + tax_freq_over + 
				"|" + remun_code + "|" + bus_nbr_grp + "|" + report_entity + "|" + qc_ent_nbr_grp + "|" + wc_class + 
				"|" + currency_code + "|" + curr_nd + "|" + hm_process_lev + "|" + ca_wc_class + "|" + country_code + 
				"|" + pens_seq_nbr + "|" + abn_obj_id + "|" + pay_units + "|" + unit_measure + "|" + user_id + 
				"|" + date_stamp + "|" + non_earnings + "|" + orig_obj_id + "|" + record_type + "|" + attend_code + 
				"|" + reason_code + "|" + tes_obj_id + "|" + retro_pension + "|" + service_code + "|" + time_stamp + 
				"|" + create_date + "|" + create_time + "|" + create_user_id + "|" + prtset8_ss_sw + "|" + 
				prtset9_ss_sw);		
	}
}
